
<%@ page import="sctu.User" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.List" %><%--
  Created by IntelliJ IDEA.
  User: 肖林
  Date: 2018/5/15
  Time: 16:39
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<style type="text/css">
    table {
        border-collapse: collapse;
    }

    td {
        border: 1px solid #000;
        padding: 10px;
    }
</style>

<%


    List<User> userList = new ArrayList<User>();

    // 3+1
    Class.forName("com.mysql.jdbc.Driver");
    Connection connection = null;
    Statement statement = null;
    ResultSet resultSet = null;

    String sql = "select * from t_user";

    connection = DriverManager.getConnection(
            "jdbc:mysql://localhost:3306/javaweb_2018?serverTimezone=UTC",
            "root",
            "195122"
    );

    statement = connection.createStatement();

    resultSet = statement.executeQuery(sql);

    while(resultSet.next()){

        int id = resultSet.getInt(1);
        String name = resultSet.getString(2);
        String password = resultSet.getString(3);

        // [封装]在user中
        User user = new User();
        user.setId(id);
        user.setName(name);
        user.setPassword(password);

        userList.add(user);
    }
    // 数据库 -> List

    resultSet.close();
    statement.close();
    connection.close();

    // 易出错点2
    pageContext.setAttribute("userList", userList);

%>

<table>
    <tr>
        <td>编号</td>
        <td>用户名</td>
        <td>密码</td>
        <td>操作1</td>
        <td>操作2</td>
    </tr>


    <%--易出错点3: userList少 ${}--%>
    <c:forEach var="user" items="${userList}">
        <tr>
            <td>${user.id}</td>
            <td>${user.name}</td>
            <td>${user.password}</td>
            <td>修改</td>
            <td>删除</td>
        </tr>
    </c:forEach>


</table>
</body>
</html>
